--------------------------------------------------
-- ServerActivity
IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[ServerActivity]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
	CREATE TABLE [dbo].[ServerActivity]
	(
		ID						integer primary key IDENTITY NOT NULL,
		OCCURRED				datetime NOT NULL,
		CONVERSATION_GUID		uniqueidentifier,
		METHOD					VARCHAR(200),
		DETAIL					VARCHAR(300),
		CONTEXT					VARCHAR(500)
	);
END
GO